<?php
class Portfoliomanager_Data_Getcurrentportfolio implements Portfoliomanager_Data_Mainable{
    
    private $core_controller_selectdata;
    
    public function __construct() {
        $this->core_controller_selectdata = new Core_Controller_Selectdata;
    }
    
    public function main(array $variables = null) {
        $variables['query'] = "SELECT portfolio_settings.item_name, portfolio_settings.subcategory_name, portfolio_settings.status_name, portfolio_settings.access_level, portfolio_meta_values.item_meta_title, portfolio_meta_values.item_meta_description, portfolio_meta_values.item_meta_keywords, portfolio_content_values.item_title, portfolio_content_values.item_description, portfolio_content_values.item_content, portfolio_content_values.item_image FROM portfolio_settings, portfolio_meta_values, portfolio_content_values WHERE portfolio_settings.item_name = '".$variables['get']['name']."' AND portfolio_settings.item_name = portfolio_meta_values.item_name AND portfolio_settings.item_name = portfolio_content_values.item_name AND portfolio_settings.item_name = portfolio_content_values.item_name AND portfolio_content_values.item_name = portfolio_meta_values.item_name;";
        //echo $variables['query'];
        //die();
        return $this->core_controller_selectdata->main($variables);
    }
}
